<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>About drilling</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
img_whs1 { border:none; width:963px; height:529px; border-style:none; }
img_whs2 { border:none; width:865px; height:534px; border-style:none; }
ul.whs3 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nAnalyzing additional levels of data: Drilling and Linking\nAbout drilling");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>About drilling</h1>
<p>Drilling lets you view report data at levels other than that displayed 
 in the report. For an introduction to drilling, levels, and hierarchies, 
 see the <span style="font-style: italic;"><I>MicroStrategy Basic Reporting 
 Guide</I></span>.</p>
<p>You can drill down, up, or across attributes, some metrics, custom groups, 
 and consolidations displayed in a report. </p>
<h2>Drilling example</h2>
<p>The results on your report are organized by countries and stores (the 
 attributes Country and Store are on the report). The report shows sales 
 by Country. You can drill down from the country level to see the sales 
 for the regions that make up that country. You can also drill up from 
 stores to view sales for the cities where those stores are located.</p>
<p>The relationship between attributes defines how you can drill between 
 them. Country is the parent of Region, so you drill down from Country 
 to Region. Region is the child of Country, so you drill up from Region 
 to Country. Region is the parent of City, City is the child of Region 
 and the parent of Store, and Store is the child of City.</p>
<p>The image below shows a report that allows you to drill on any of the 
 Customer Regions: </p>
<p><img src="images/image4.gif" width="963px" height="529px" border="0" class="img_whs1"></p>
<h3><span style="font-weight: normal;">Below is the drilled-to report, 
 which is the result of drilling on the Southeast Region in the report 
 above: </span></h3>
<h3><img src="images/drilling.gif" width="865px" height="534px" border="0" class="img_whs2"></h3>
<h3>Related topics</h3>
<ul type="disc" class="whs3">
	
<li class=p><p>
<a href="Drilling_on_a_grid_report.htm">Drilling on 
 a grid report</a></p></li>
	
<li class=p><p>
<a href="Drilling_on_a_graph_report.htm">Drilling on 
 a graph report</a></p></li>
	
<li class=p><p>
<a HREF="Drilling_Page-by_objects.htm">Drilling on objects 
 on the Page-by axis</a></p></li>
	
<li class=p><p>
<a href="Drill_dialog_box.htm">Using the Drill panel</a></p></li>
</ul>
<p>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
